--them cot trng bang CHITIEU
ALTER TABLE [DM].[CHITIEU] ADD CHO_PHEP_TINH_TONG int null;


UPDATE [DM].[CHITIEU]
SET [CHO_PHEP_TINH_TONG] = 1;

UPDATE [DM].[CHITIEU]
SET [CHO_PHEP_TINH_TONG] = 0
WHERE [DON_VI_TINH] = '%'
OR [DON_VI_TINH] = 'NA';



or:




--Cap nhat gia tri
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 924;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 925;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 926;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 927;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 928;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 929;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 930;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 931;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 932;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 933;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 934;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 935;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 936;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 937;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 938;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 939;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 940;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 941;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 944;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 945;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 942;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 943;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 946;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 947;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 948;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 949;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 950;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1010;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 951;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1256;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1257;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1258;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1259;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1260;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 952;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 953;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 954;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 956;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 957;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 955;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 958;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 959;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 960;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 961;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 0	WHERE [CHI_TIEU_ID] = 962;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1262;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 963;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 964;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 965;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 966;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 967;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 968;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 969;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 970;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 971;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 972;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 973;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 974;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 975;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 976;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1115;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 978;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 979;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 980;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 981;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 982;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 983;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 984;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 985;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 986;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 987;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 988;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 989;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 990;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 991;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 992;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 993;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 994;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 995;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 996;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 997;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 998;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 999;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1000;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1001;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1002;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1003;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1004;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1005;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1006;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1007;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1008;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1009;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1011;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1015;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1016;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1017;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1018;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1019;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1020;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1021;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1022;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 0	WHERE [CHI_TIEU_ID] = 1023;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1024;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1025;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1026;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1027;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1028;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1029;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1030;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1031;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1032;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1033;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1034;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1035;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1040;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1041;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1042;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1043;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1044;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1261;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1045;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1046;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1047;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1056;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1057;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1062;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1063;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1170;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1171;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1172;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1173;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1174;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1175;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1176;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1177;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1178;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1179;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1180;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1181;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1182;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1183;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1184;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1185;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1186;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1187;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1188;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1189;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1190;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1191;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1192;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1193;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1194;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1195;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1196;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1197;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1147;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1148;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1149;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1150;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1151;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1152;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1153;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1154;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1155;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1263;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1264;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1265;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1266;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1267;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1156;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1157;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1158;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1159;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1160;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1161;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1162;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1163;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1164;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1165;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1166;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1167;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1168;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1169;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1198;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1199;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1200;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1201;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1202;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1203;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1204;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1205;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1206;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1207;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1208;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1209;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1210;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1211;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1212;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1213;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1214;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1215;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1216;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1217;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1218;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1219;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1220;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1221;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1222;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1223;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1224;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1225;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1226;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1227;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1228;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1229;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1230;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1231;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1232;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1233;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1234;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1238;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1235;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1236;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1237;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1239;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1240;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1241;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1242;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1243;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1249;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1250;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1251;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1252;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1253;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1254;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1244;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1245;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1246;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1247;
UPDATE [DM].[CHITIEU] SET [CHO_PHEP_TINH_TONG] = 1	WHERE [CHI_TIEU_ID] = 1248;


